﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ControlBaoCaoDoanhSoLai.ascx.cs" Inherits="WebUserControl_ControlBaoCaoDoanhSoLai" %>
<%--<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v9.2, Version=9.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid" tagprefix="dxwpg" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.2, Version=9.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dxe" %>
<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v9.2.Export, Version=9.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraPivotGrid.Web" tagprefix="dxpgw" %>
--%>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.2, Version=9.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dxe" %>

<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v9.2, Version=9.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid" tagprefix="dxwpg" %>
<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v9.2.Export, Version=9.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraPivotGrid.Web" tagprefix="dxpgw" %>

<style type="text/css">
.dxpgControl
{
	color: Black;
	font: 9pt Tahoma;
	border: solid 1px #9f9f9f;
	background-color: white;
}
.dxpgContainerCell
{
	vertical-align: top;
}
.dxpgMainTable
{
	color: Black;
	font: 9pt Tahoma;
	border: 0px;
	border-collapse: separate;
	width: 100%;
}
.dxpgTopPager
{
	border-top: none;
	border-right: none;
	border-left: none;
	border-bottom: solid 1px #9f9f9f;
	background-color: #F2F2F2;
	padding-bottom:2px;	
}
.dxpControl
{
	font: 9pt Tahoma;
	color: black;
	padding: 5px 2px 5px 2px;
}
.dxpSummary
{
	font: 9pt Tahoma;
	color: black;
	white-space: nowrap;
	text-align: center;
	vertical-align: middle;
	padding: 1px 4px 0px 4px;
}
.dxpDisabled
{
	color: #acacac;
	border-color: #808080;
	cursor: default;
}

.dxpDisabledButton
{
	font: 9pt Tahoma;
	color: black;
	text-decoration: none;
}
.dxpButton
{
	font: 9pt Tahoma;
	color: #394EA2;
	text-decoration: underline;
	white-space: nowrap;
	text-align: center;
	vertical-align: middle;
}
.dxpCurrentPageNumber
{
	font: 9pt Tahoma;
	color: black;
	font-weight: bold;
	text-decoration: none;
	padding: 1px 3px 0px 3px;
}
.dxpPageNumber
{
	font: 9pt Tahoma;
	color: #394EA2;
	text-decoration: underline;
	text-align: center;
	vertical-align: middle;
	padding: 1px 5px 0px 5px;
}
.dxpgEmptyArea
{
	cursor: default;
	padding-top: 6px;
	padding-left: 6px;
	padding-bottom: 7px;
	padding-right: 6px;
}
.dxpgFilterArea
{
	background-color: #dcdcdc;
	color: #808080;
	border-bottom-style: solid;
}
.dxpgArea
{
	border: solid 1px #9f9f9f;
	background-color: #ededed;
	border-left-style: none;
	border-top-style: none;
	border-bottom-style: none;
	border-right-style: none;
}
.dxpgColumnArea
{
	border-bottom-style: solid;
}
.dxpgHeaderTable
{
	border-width: 1px;
	width: 100%;
}
.dxpgHeader
{
	border-width: 0px;
	color: Black;
	background-color: #dcdcdc;
	cursor: pointer;
	white-space: nowrap;	
}
.dxpgHeaderText
{
	padding-left: 6px;
	padding-right: 6px;
	padding-top: 3px;
	padding-bottom: 4px;
}
.dxpgHeaderSort
{
	padding-left: 0px;
	padding-right: 4px;
	padding-top: 0px;
	padding-bottom: 0px;
	vertical-align: middle;
}
.dxpgHeaderFilter
{
	padding-left: 0px;
	padding-right: 2px;
	padding-top: 2px;
	padding-bottom: 2px;
	vertical-align: middle;	
}
.dxpgColumnGrandTotalFieldValue
{
	background-color: #bdbdbd;
	border-left-style: solid;
	border-bottom-style: solid;
	border-right-style: none;
	border-top-style: none;
}
.dxpgColumnTotalFieldValue
{
	background-color: #c9c9c9;
	border-left-style: solid;
	border-bottom-style: solid;
	border-right-style: none;
	border-top-style: none;
}
.dxpgColumnFieldValue
{
	background-color: #dcdcdc;
	border: solid 1px #9f9f9f;
	border-left-style: solid;
	border-bottom-style: solid;
	border-right-style: none;
	border-top-style: none;
	padding: 4px 6px;
	font-weight: normal;
	text-align: left;	
}
.dxpgRowFieldValue
{
	background-color: #dcdcdc;
	border: solid 1px #9f9f9f;
	border-left-style: none;
	border-bottom-style: none;
	border-right-style: solid;
	border-top-style: solid;
	padding: 3px 6px 4px 6px;
	font-weight: normal;
	text-align: left;
}
.dxpgCollapsedButton
{
	vertical-align: -1px;
	border: 0px;
	margin-right: 5px;
}
.dxpgGrandTotalCell
{
	background-color: #e2e2e2;
}
.dxpgCell
{
	text-align: right;
	background-color: White;	
	border-color: #cecece;
	border-width: 1px;
	border-top-style: solid;
	border-left-style: solid;
	border-bottom-style: none;
	border-right-style: none;
	padding: 4px;
	padding-top:3px;
	white-space: nowrap;
}
.dxpgBottomPager
{
	border-top: solid 1px #9f9f9f;
	border-bottom: none;
	border-right: none;
	border-left: none;
	background-color: #F2F2F2;
	padding-bottom:2px;
}
    </style>
<p>
    &nbsp;</p>
<p>
    
</p>
<p>
    &nbsp;</p>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<Triggers>
<asp:PostBackTrigger ControlID="ASPxButton1" />
</Triggers>
    <ContentTemplate>
        <br />
        &nbsp;<br />
        <br />
        <dxe:ASPxButton ID="ASPxButton1" runat="server" onclick="ASPxButton1_Click" 
            Text="Export">
        </dxe:ASPxButton>
    <br />
    
        <dxpgw:ASPxPivotGridExporter ASPxPivotGridID="ASPxPivotGrid1" ID="ASPxPivotGridExporter1" runat="server">
        </dxpgw:ASPxPivotGridExporter>
    
        <dxwpg:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server" 
    DataSourceID="SqlDataSource1">
            <Fields>
                <dxwpg:PivotGridField ID="field" Area="RowArea" 
            AreaIndex="0" Caption="inclasskey" FieldName="inclasskey">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field1" Area="RowArea" 
            AreaIndex="1" Caption="BrandName" FieldName="BrandName">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field2" Area="RowArea" 
            AreaIndex="2" Caption="commodkey" FieldName="commodkey">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field3" Area="RowArea" 
            AreaIndex="3" Caption="CategoryCode" FieldName="CategoryCode">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field4" Area="RowArea" 
            AreaIndex="4" Caption="ItemName" FieldName="ItemName">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field5" Area="RowArea" 
            AreaIndex="5" Caption="SiteCode" FieldName="SiteCode">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field6" Area="RowArea" 
            AreaIndex="6" Caption="WhseCode" FieldName="WhseCode">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field7" Area="RowArea" 
            AreaIndex="7" Caption="CustKey" FieldName="CustKey">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field8" Area="RowArea" 
            AreaIndex="8" Caption="SkuCode" FieldName="SkuCode">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field9" Area="RowArea" 
            AreaIndex="9" Caption="SalespKey" FieldName="SalespKey">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field10" Area="RowArea" 
            AreaIndex="10" Caption="CustClass" FieldName="CustClass">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field11" Area="RowArea" 
            AreaIndex="11" Caption="OffDate" FieldName="OffDate">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field12" Area="RowArea" 
            AreaIndex="12" Caption="OrdQty" FieldName="OrdQty">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field13" Area="RowArea" 
            AreaIndex="13" Caption="OrdAmt" FieldName="OrdAmt">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field14" Area="RowArea" 
            AreaIndex="14" Caption="OffQty" FieldName="OffQty">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field15" Area="RowArea" 
            AreaIndex="15" Caption="OffAmt" FieldName="OffAmt">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field16" Area="RowArea" 
            AreaIndex="16" Caption="OffDsc" FieldName="OffDsc">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field17" Area="RowArea" 
            AreaIndex="17" Caption="RetQty" FieldName="RetQty">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field18" Area="RowArea" 
            AreaIndex="18" Caption="RetAmt" FieldName="RetAmt">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field19" Area="RowArea" 
            AreaIndex="19" Caption="RetDsc" FieldName="RetDsc">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field20" Area="RowArea" 
            AreaIndex="20" Caption="Chanel" FieldName="Chanel">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field21" Area="RowArea" 
            AreaIndex="21" Caption="OffCOGS" FieldName="OffCOGS">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field22" Area="RowArea" 
            AreaIndex="22" Caption="RetCOGS" FieldName="RetCOGS">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field23" Area="RowArea" 
            AreaIndex="23" Caption="Program_ID" FieldName="Program_ID">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field24" Area="RowArea" 
            AreaIndex="24" Caption="OffTaxAmt" FieldName="OffTaxAmt">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field25" Area="RowArea" 
            AreaIndex="25" Caption="RetTaxAmt" FieldName="RetTaxAmt">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field26" Area="RowArea" 
            AreaIndex="26" Caption="TeamLeader" FieldName="TeamLeader">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field27" Area="RowArea" 
            AreaIndex="27" Caption="Recommender" FieldName="Recommender">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field28" Area="RowArea" 
            AreaIndex="28" Caption="Team" FieldName="Team">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field29" Area="RowArea" 
            AreaIndex="29" Caption="salesp_name" FieldName="salesp_name">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field30" Area="RowArea" 
            AreaIndex="30" Caption="customer_name" FieldName="customer_name">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field31" Area="RowArea" 
            AreaIndex="31" Caption="Class_Descr" FieldName="Class_Descr">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField ID="field32" Area="RowArea" 
            AreaIndex="32" Caption="Class_Descr" FieldName="Class_Descr">
                </dxwpg:PivotGridField>
            </Fields>
        </dxwpg:ASPxPivotGrid>
        
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="Data Source=SMART-02D4BF19E\SQLEXPRESS;Initial Catalog=CosmeticCenter;Integrated Security=True" 
            ProviderName="System.Data.SqlClient" SelectCommand="REPORT_CUSTOFFTAKE" 
            SelectCommandType="StoredProcedure"></asp:SqlDataSource>
        <br />
        
        <br />
    </ContentTemplate>
</asp:UpdatePanel>
<p>
    &nbsp;</p>


